Configuring: Replace Strings

Select which values within the string fields need to be replaced. You can only select one string field at a time.

Worked example: Replace strings

Steps to configure

1. Field selection: Select the field containing string values to edit. Only one field can be edited at a time.

2. Value replacement: Select the string and enter the replacement value.

3. Execute: The selected fields will be replaced in the dataset.

Step 1: Field selection

From the list of string fields, select the string field that you want to edit.

• Default: All string fields are placed in the available window.

• Minimum configuration: Only one field can be selected.

Step 2: Value replacement

Select the string values to be replaced.

• The text box of strings to be replaced only displays the first 100 distinct values.

• The case sensitivity of this field is determined by your installation configuration of SQL Server. Default installation of SQL Server is case insensitive.

• The value entered must be valid and cannot exceed the maximum length of a string.

• You cannot replace the same string twice.

• You have the option to replace all the null values inside the field with a valid value.

• Default: No strings are selected.

• Minimum configuration: At least one string must be replaced with a valid value.

Step 3: Execute

The dataset is modified to contain the replaced string values and/or the replaced null values.

---

Related topics:

• Overview of operation: Replace strings

• Worked example: Replace strings

• Overview of operations

• Technical comparison of operations

• Overview of icons